walmart_stores

Dataset statistics

Number of variables	23
Number of observations	5282
Missing cells	9871
Missing cells (%)	8.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	913.1 KiB
Average record size in memory	177.0 B

Variable types

Numeric	6
Text	6
Categorical	5
Boolean	6

Alerts

`Modified_Operating_Hours_` has constant value ""	Constant
`Fuel_Station_open_to_public_` has constant value ""	Constant
`businessunit_number` is highly overall correlated with `businessunit_status_code` and 2 other fields	High correlation
`businessunit_status_code` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`bu_num` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`businessunit_banner_description` is highly overall correlated with `businessunit_type_description`	High correlation
`businessunit_type_description` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`businessunit_isstoreopen` is highly overall correlated with `businessunit_status_code`	High correlation
`Pharmacy_open_to_public_` is highly overall correlated with `Grocery_delivery_status` and 1 other fields	High correlation
`Grocery_delivery_status` is highly overall correlated with `Pharmacy_open_to_public_` and 1 other fields	High correlation
`Online_grocery_pickup_status` is highly overall correlated with `Pharmacy_open_to_public_` and 1 other fields	High correlation
`businessunit_banner_description` is highly imbalanced (56.5%)	Imbalance
`businessunit_isstoreopen` is highly imbalanced (96.3%)	Imbalance
`op_status` is highly imbalanced (99.3%)	Imbalance
`Pharmacy_open_to_public_` is highly imbalanced (99.7%)	Imbalance
`Modified_Operating_Hours_` has 5279 (99.9%) missing values	Missing
`Grocery_delivery_service` has 467 (8.8%) missing values	Missing
`Grocery_delivery_status` has 2417 (45.8%) missing values	Missing
`Online_grocery_pickup` has 138 (2.6%) missing values	Missing
`Online_grocery_pickup_status` has 1505 (28.5%) missing values	Missing
`objectid` has unique values	Unique
`businessunit_number` has unique values	Unique
`bu_num` has unique values	Unique

Reproduction

Analysis started	2023-10-22 10:06:25.598449
Analysis finished	2023-10-22 10:06:34.795134
Duration	9.2 seconds
Software version	ydata-profiling vv4.6.0
Download configuration	config.json

X
Real number (ℝ)

Distinct	5277
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-91.459635

Minimum	-159.36503
Maximum	0
Zeros	3
Zeros (%)	0.1%
Negative	5279
Negative (%)	99.9%
Memory size	41.4 KiB

Quantile statistics

Minimum	-159.36503
5-th percentile	-119.17875
Q1	-97.117344
median	-88.406115
Q3	-81.745786
95-th percentile	-74.65466
Maximum	0
Range	159.36503
Interquartile range (IQR)	15.371558

Descriptive statistics

Standard deviation	13.682249
Coefficient of variation (CV)	-0.14959877
Kurtosis	2.2599628
Mean	-91.459635
Median Absolute Deviation (MAD)	7.536797
Skewness	-0.86057402
Sum	-483089.79
Variance	187.20393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3	0.1%
-84.848736	2	< 0.1%
-90.324403	2	< 0.1%
-84.599961	2	< 0.1%
-94.149054	1	< 0.1%
-83.470749	1	< 0.1%
-97.405724	1	< 0.1%
-94.472943	1	< 0.1%
-122.679409	1	< 0.1%
-97.375174	1	< 0.1%
Other values (5267)	5267	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-159.365025	1	< 0.1%
-158.075334	1	< 0.1%
-158.034591	1	< 0.1%
-158.005571	1	< 0.1%
-157.978362	1	< 0.1%
-157.974452	1	< 0.1%
-157.862004	1	< 0.1%
-157.843233	1	< 0.1%
-157.842705	1	< 0.1%
-156.454892	1	< 0.1%

Value	Count	Frequency (%)
0	3	0.1%
-65.674303	1	< 0.1%
-65.807268	1	< 0.1%
-65.889641	1	< 0.1%
-65.995746	1	< 0.1%
-65.997031	1	< 0.1%
-66.015882	1	< 0.1%
-66.020899	1	< 0.1%
-66.076049	1	< 0.1%
-66.087612	1	< 0.1%

Y
Real number (ℝ)

Distinct	5276
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.418339

Minimum	0
Maximum	64.856378
Zeros	3
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	41.4 KiB

Quantile statistics

Minimum	0
5-th percentile	28.022818
Q1	32.943558
median	36.165766
Q3	40.349658
95-th percentile	44.537943
Maximum	64.856378
Range	64.856378
Interquartile range (IQR)	7.4061002

Descriptive statistics

Standard deviation	5.2857374
Coefficient of variation (CV)	0.14513944
Kurtosis	1.648455
Mean	36.418339
Median Absolute Deviation (MAD)	3.6488895
Skewness	-0.22170713
Sum	192361.67
Variance	27.93902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3	0.1%
42.999723	2	< 0.1%
41.473938	2	< 0.1%
29.470675	2	< 0.1%
33.401188	2	< 0.1%
37.340296	1	< 0.1%
37.072913	1	< 0.1%
45.595564	1	< 0.1%
27.679204	1	< 0.1%
28.617165	1	< 0.1%
Other values (5266)	5266	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	0.1%
17.980621	1	< 0.1%
17.993681	1	< 0.1%
17.99736	1	< 0.1%
18.016813	1	< 0.1%
18.044336	1	< 0.1%
18.122626	1	< 0.1%
18.141237	1	< 0.1%
18.155224	1	< 0.1%
18.243301	1	< 0.1%

Value	Count	Frequency (%)
64.856378	1	< 0.1%
61.568719	1	< 0.1%
61.309037	1	< 0.1%
61.211988	1	< 0.1%
61.192239	1	< 0.1%
61.140195	1	< 0.1%
60.564278	1	< 0.1%
57.811934	1	< 0.1%
55.375474	1	< 0.1%
48.818547	1	< 0.1%

objectid
Real number (ℝ)

UNIQUE

Distinct	5282
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32408.828

Minimum	29040
Maximum	36706
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.4 KiB

Quantile statistics

Minimum	29040
5-th percentile	29378.05
Q1	30475.25
median	32133.5
Q3	34233.75
95-th percentile	36273.95
Maximum	36706
Range	7666
Interquartile range (IQR)	3758.5

Descriptive statistics

Standard deviation	2175.711
Coefficient of variation (CV)	0.067133282
Kurtosis	-1.1003089
Mean	32408.828
Median Absolute Deviation (MAD)	1874.5
Skewness	0.27077408
Sum	1.7118343 × 10⁸
Variance	4733718.3
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29040	1	< 0.1%
33551	1	< 0.1%
33543	1	< 0.1%
33542	1	< 0.1%
33541	1	< 0.1%
33540	1	< 0.1%
33536	1	< 0.1%
33535	1	< 0.1%
33533	1	< 0.1%
33532	1	< 0.1%
Other values (5272)	5272	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29040	1	< 0.1%
29041	1	< 0.1%
29042	1	< 0.1%
29043	1	< 0.1%
29044	1	< 0.1%
29045	1	< 0.1%
29046	1	< 0.1%
29047	1	< 0.1%
29048	1	< 0.1%
29049	1	< 0.1%

Value	Count	Frequency (%)
36706	1	< 0.1%
36705	1	< 0.1%
36704	1	< 0.1%
36702	1	< 0.1%
36700	1	< 0.1%
36698	1	< 0.1%
36695	1	< 0.1%
36693	1	< 0.1%
36690	1	< 0.1%
36688	1	< 0.1%

businessunit_name
Text

Distinct	4824
Distinct (%)	91.3%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Length

Max length	42
Median length	36
Mean length	13.991102
Min length	4

Characters and Unicode

Total characters	73901
Distinct characters	70
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4462 ?
Unique (%)	84.5%

Sample

1st row	ROGERS, AR
2nd row	TUNKHANNOCK, PA
3rd row	TAHLEQUAH OK
4th row	TRACY, CA
5th row	BENTONVILLE, AR

Value	Count	Frequency (%)
tx	592	4.5%
fl	377	2.8%
ca	306	2.3%
ga	212	1.6%
nc	211	1.6%
il	180	1.4%
oh	167	1.3%
city	163	1.2%
la	158	1.2%
pa	157	1.2%
Other values (3263)	10775	81.0%

Most occurring characters

Value	Count	Frequency (%)
	8025	10.9%
A	6403	8.7%
N	5146	7.0%
E	5135	6.9%
L	4890	6.6%
O	4633	6.3%
I	3823	5.2%
R	3744	5.1%
T	3683	5.0%
S	3416	4.6%
Other values (60)	25003	33.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	60663	82.1%
Space Separator	8025	10.9%
Other Punctuation	2603	3.5%
Lowercase Letter	927	1.3%
Close Punctuation	683	0.9%
Open Punctuation	683	0.9%
Decimal Number	250	0.3%
Dash Punctuation	65	0.1%
Modifier Symbol	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	6403	10.6%
N	5146	8.5%
E	5135	8.5%
L	4890	8.1%
O	4633	7.6%
I	3823	6.3%
R	3744	6.2%
T	3683	6.1%
S	3416	5.6%
C	2580	4.3%
Other values (16)	17210	28.4%

Lowercase Letter

Value	Count	Frequency (%)
a	114	12.3%
e	93	10.0%
o	92	9.9%
n	80	8.6%
l	78	8.4%
r	76	8.2%
i	57	6.1%
t	55	5.9%
s	55	5.9%
d	33	3.6%
Other values (14)	194	20.9%

Decimal Number

Value	Count	Frequency (%)
1	83	33.2%
2	44	17.6%
0	38	15.2%
6	16	6.4%
3	15	6.0%
4	14	5.6%
7	14	5.6%
5	11	4.4%
8	10	4.0%
9	5	2.0%

Other Punctuation

Value	Count	Frequency (%)
,	2430	93.4%
.	86	3.3%
/	42	1.6%
&	38	1.5%
'	7	0.3%

Space Separator

Value	Count	Frequency (%)
	8025	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	683	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	683	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	65	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	61590	83.3%
Common	12311	16.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	6403	10.4%
N	5146	8.4%
E	5135	8.3%
L	4890	7.9%
O	4633	7.5%
I	3823	6.2%
R	3744	6.1%
T	3683	6.0%
S	3416	5.5%
C	2580	4.2%
Other values (40)	18137	29.4%

Common

Value	Count	Frequency (%)
	8025	65.2%
,	2430	19.7%
)	683	5.5%
(	683	5.5%
.	86	0.7%
1	83	0.7%
-	65	0.5%
2	44	0.4%
/	42	0.3%
0	38	0.3%
Other values (10)	132	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	73901	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8025	10.9%
A	6403	8.7%
N	5146	7.0%
E	5135	6.9%
L	4890	6.6%
O	4633	6.3%
I	3823	5.2%
R	3744	5.1%
T	3683	5.0%
S	3416	4.6%
Other values (60)	25003	33.8%

businessunit_number
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	5282
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3196.6717

Minimum	1
Maximum	11017
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.4 KiB

Quantile statistics

Minimum	1
5-th percentile	279.05
Q1	1376.25
median	2818.5
Q3	4946.75
95-th percentile	6970.85
Maximum	11017
Range	11016
Interquartile range (IQR)	3570.5

Descriptive statistics

Standard deviation	2167.5044
Coefficient of variation (CV)	0.67805035
Kurtosis	-0.72529718
Mean	3196.6717
Median Absolute Deviation (MAD)	1698.5
Skewness	0.47916053
Sum	16884820
Variance	4698075.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
5907	1	< 0.1%
590	1	< 0.1%
59	1	< 0.1%
5899	1	< 0.1%
5898	1	< 0.1%
5894	1	< 0.1%
5893	1	< 0.1%
5891	1	< 0.1%
5890	1	< 0.1%
Other values (5272)	5272	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
11017	1	< 0.1%
9894	1	< 0.1%
8958	1	< 0.1%
8930	1	< 0.1%
8861	1	< 0.1%
8331	1	< 0.1%
8299	1	< 0.1%
8298	1	< 0.1%
8297	1	< 0.1%
8296	1	< 0.1%

businessunit_banner_description
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

WM Supercenter	3591
Neighborhood Market	687
Sam's Club	605
Wal-Mart	364
WM On Campus/RX Facilities	22
Other values (5)	13

Length

Max length	26
Median length	14
Mean length	13.839644
Min length	5

Characters and Unicode

Total characters	73101
Distinct characters	43
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.1%

Sample

1st row	WM Supercenter
2nd row	WM Supercenter
3rd row	WM Supercenter
4th row	WM Supercenter
5th row	WM Supercenter

Common Values

Value	Count	Frequency (%)
WM Supercenter	3591	68.0%
Neighborhood Market	687	13.0%
Sam's Club	605	11.5%
Wal-Mart	364	6.9%
WM On Campus/RX Facilities	22	0.4%
Walmart Fuel Station	8	0.2%
STAND ALONE PICKUP	2	< 0.1%
MOBILE OPTICAL	1	< 0.1%
WM ONLINE PICKUP/DELIVERY	1	< 0.1%
Other	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wm	3614	35.2%
supercenter	3591	35.0%
neighborhood	687	6.7%
market	687	6.7%
sam's	605	5.9%
club	605	5.9%
wal-mart	364	3.5%
on	22	0.2%
campus/rx	22	0.2%
facilities	22	0.2%
Other values (11)	35	0.3%

Most occurring characters

Value	Count	Frequency (%)
e	12178	16.7%
r	8929	12.2%
	4972	6.8%
t	4689	6.4%
M	4666	6.4%
u	4226	5.8%
S	4206	5.8%
W	3986	5.5%
n	3621	5.0%
p	3613	4.9%
Other values (33)	18015	24.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	52806	72.2%
Uppercase Letter	14331	19.6%
Space Separator	4972	6.8%
Other Punctuation	628	0.9%
Dash Punctuation	364	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	4666	32.6%
S	4206	29.3%
W	3986	27.8%
N	693	4.8%
C	631	4.4%
F	30	0.2%
O	28	0.2%
R	23	0.2%
X	22	0.2%
I	7	< 0.1%
Other values (11)	39	0.3%

Lowercase Letter

Value	Count	Frequency (%)
e	12178	23.1%
r	8929	16.9%
t	4689	8.9%
u	4226	8.0%
n	3621	6.9%
p	3613	6.8%
c	3613	6.8%
a	2088	4.0%
o	2069	3.9%
h	1375	2.6%
Other values (8)	6405	12.1%

Other Punctuation

Value	Count	Frequency (%)
'	605	96.3%
/	23	3.7%

Space Separator

Value	Count	Frequency (%)
	4972	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	364	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	67137	91.8%
Common	5964	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12178	18.1%
r	8929	13.3%
t	4689	7.0%
M	4666	6.9%
u	4226	6.3%
S	4206	6.3%
W	3986	5.9%
n	3621	5.4%
p	3613	5.4%
c	3613	5.4%
Other values (29)	13410	20.0%

Common

Value	Count	Frequency (%)
	4972	83.4%
'	605	10.1%
-	364	6.1%
/	23	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	73101	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12178	16.7%
r	8929	12.2%
	4972	6.8%
t	4689	6.4%
M	4666	6.4%
u	4226	5.8%
S	4206	5.8%
W	3986	5.5%
n	3621	5.0%
p	3613	4.9%
Other values (33)	18015	24.6%

businessunit_type_description
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Retail	4677
Wholesale	605

Length

Max length	9
Median length	6
Mean length	6.3436198
Min length	6

Characters and Unicode

Total characters	33507
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Retail
2nd row	Retail
3rd row	Retail
4th row	Retail
5th row	Retail

Common Values

Value	Count	Frequency (%)
Retail	4677	88.5%
Wholesale	605	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
retail	4677	88.5%
wholesale	605	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	5887	17.6%
l	5887	17.6%
a	5282	15.8%
R	4677	14.0%
t	4677	14.0%
i	4677	14.0%
W	605	1.8%
h	605	1.8%
o	605	1.8%
s	605	1.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28225	84.2%
Uppercase Letter	5282	15.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5887	20.9%
l	5887	20.9%
a	5282	18.7%
t	4677	16.6%
i	4677	16.6%
h	605	2.1%
o	605	2.1%
s	605	2.1%

Uppercase Letter

Value	Count	Frequency (%)
R	4677	88.5%
W	605	11.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33507	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5887	17.6%
l	5887	17.6%
a	5282	15.8%
R	4677	14.0%
t	4677	14.0%
i	4677	14.0%
W	605	1.8%
h	605	1.8%
o	605	1.8%
s	605	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33507	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5887	17.6%
l	5887	17.6%
a	5282	15.8%
R	4677	14.0%
t	4677	14.0%
i	4677	14.0%
W	605	1.8%
h	605	1.8%
o	605	1.8%
s	605	1.8%

businessunit_isstoreopen
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.3 KiB

True	5261
False	21

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5261	99.6%
False	21	0.4%

facilitydetails_location_locati
Text

Distinct	5266
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Length

Max length	41
Median length	35
Mean length	17.632526
Min length	3

Characters and Unicode

Total characters	93135
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5257 ?
Unique (%)	99.5%

Sample

1st row	2110 W WALNUT ST
2nd row	808 HUNTER HWY
3rd row	2020 S MUSKOGEE AVE
4th row	3010 W GRANT LINE RD
5th row	406 S WALTON BLVD

Value	Count	Frequency (%)
rd	998	5.0%
st	791	4.0%
ave	619	3.1%
dr	572	2.9%
blvd	570	2.9%
s	534	2.7%
w	506	2.6%
n	502	2.5%
e	469	2.4%
highway	357	1.8%
Other values (5706)	13867	70.1%

Most occurring characters

Value	Count	Frequency (%)
	14503	15.6%
E	5579	6.0%
R	4997	5.4%
A	4895	5.3%
0	4550	4.9%
1	4186	4.5%
S	3819	4.1%
N	3756	4.0%
T	3702	4.0%
D	3464	3.7%
Other values (42)	39684	42.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	56288	60.4%
Decimal Number	22207	23.8%
Space Separator	14503	15.6%
Other Punctuation	103	0.1%
Dash Punctuation	24	< 0.1%
Lowercase Letter	10	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	5579	9.9%
R	4997	8.9%
A	4895	8.7%
S	3819	6.8%
N	3756	6.7%
T	3702	6.6%
D	3464	6.2%
L	3372	6.0%
O	2969	5.3%
I	2735	4.9%
Other values (17)	17000	30.2%

Decimal Number

Value	Count	Frequency (%)
0	4550	20.5%
1	4186	18.8%
5	2654	12.0%
2	2543	11.5%
3	1923	8.7%
4	1600	7.2%
7	1285	5.8%
6	1243	5.6%
9	1118	5.0%
8	1105	5.0%

Lowercase Letter

Value	Count	Frequency (%)
y	2	20.0%
d	2	20.0%
k	1	10.0%
w	1	10.0%
c	1	10.0%
a	1	10.0%
m	1	10.0%
e	1	10.0%

Other Punctuation

Value	Count	Frequency (%)
.	88	85.4%
#	6	5.8%
,	4	3.9%
/	3	2.9%
'	2	1.9%

Space Separator

Value	Count	Frequency (%)
	14503	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	24	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56298	60.4%
Common	36837	39.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	5579	9.9%
R	4997	8.9%
A	4895	8.7%
S	3819	6.8%
N	3756	6.7%
T	3702	6.6%
D	3464	6.2%
L	3372	6.0%
O	2969	5.3%
I	2735	4.9%
Other values (25)	17010	30.2%

Common

Value	Count	Frequency (%)
	14503	39.4%
0	4550	12.4%
1	4186	11.4%
5	2654	7.2%
2	2543	6.9%
3	1923	5.2%
4	1600	4.3%
7	1285	3.5%
6	1243	3.4%
9	1118	3.0%
Other values (7)	1232	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93134	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14503	15.6%
E	5579	6.0%
R	4997	5.4%
A	4895	5.3%
0	4550	4.9%
1	4186	4.5%
S	3819	4.1%
N	3756	4.0%
T	3702	4.0%
D	3464	3.7%
Other values (41)	39683	42.6%

None

Value	Count	Frequency (%)
Ñ	1	100.0%

facilitydetails_location_loca_1
Text

Distinct	2686
Distinct (%)	50.9%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Length

Max length	22
Median length	19
Mean length	8.8080273
Min length	3

Characters and Unicode

Total characters	46524
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1779 ?
Unique (%)	33.7%

Sample

1st row	ROGERS
2nd row	TUNKHANNOCK
3rd row	TAHLEQUAH
4th row	TRACY
5th row	BENTONVILLE

Value	Count	Frequency (%)
city	156	2.4%
san	68	1.0%
beach	61	0.9%
springs	59	0.9%
fort	53	0.8%
lake	45	0.7%
north	44	0.7%
west	42	0.6%
park	38	0.6%
las	37	0.6%
Other values (2541)	6025	90.9%

Most occurring characters

Value	Count	Frequency (%)
A	4466	9.6%
E	4450	9.6%
O	3788	8.1%
N	3714	8.0%
L	3700	8.0%
R	3231	6.9%
I	2948	6.3%
S	2676	5.8%
T	2551	5.5%
C	1574	3.4%
Other values (19)	13426	28.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	45176	97.1%
Space Separator	1346	2.9%
Other Punctuation	1	< 0.1%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	4466	9.9%
E	4450	9.9%
O	3788	8.4%
N	3714	8.2%
L	3700	8.2%
R	3231	7.2%
I	2948	6.5%
S	2676	5.9%
T	2551	5.6%
C	1574	3.5%
Other values (16)	12078	26.7%

Space Separator

Value	Count	Frequency (%)
	1346	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45176	97.1%
Common	1348	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	4466	9.9%
E	4450	9.9%
O	3788	8.4%
N	3714	8.2%
L	3700	8.2%
R	3231	7.2%
I	2948	6.5%
S	2676	5.9%
T	2551	5.6%
C	1574	3.5%
Other values (16)	12078	26.7%

Common

Value	Count	Frequency (%)
	1346	99.9%
.	1	0.1%
-	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46524	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	4466	9.6%
E	4450	9.6%
O	3788	8.1%
N	3714	8.0%
L	3700	8.0%
R	3231	6.9%
I	2948	6.3%
S	2676	5.8%
T	2551	5.5%
C	1574	3.4%
Other values (19)	13426	28.9%

facilitydetails_location_loca_2
Text

Distinct	1236
Distinct (%)	23.4%
Missing	1
Missing (%)	< 0.1%
Memory size	41.4 KiB

Length

Max length	28
Median length	25
Mean length	7.3130089
Min length	3

Characters and Unicode

Total characters	38620
Distinct characters	41
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	574 ?
Unique (%)	10.9%

Sample

1st row	BENTON
2nd row	WYOMING
3rd row	CHEROKEE
4th row	SAN JOAQUIN
5th row	BENTON

Value	Count	Frequency (%)
st	82	1.4%
jefferson	74	1.3%
maricopa	71	1.2%
orange	69	1.2%
san	67	1.1%
harris	61	1.0%
washington	58	1.0%
dallas	56	1.0%
tarrant	53	0.9%
city	53	0.9%
Other values (1251)	5224	89.0%

Most occurring characters

Value	Count	Frequency (%)
A	4442	11.5%
E	3651	9.5%
O	3219	8.3%
N	3171	8.2%
R	2868	7.4%
L	2636	6.8%
S	2297	5.9%
I	2105	5.5%
T	1745	4.5%
C	1456	3.8%
Other values (31)	11030	28.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	37906	98.2%
Space Separator	588	1.5%
Other Punctuation	86	0.2%
Dash Punctuation	23	0.1%
Lowercase Letter	17	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	4442	11.7%
E	3651	9.6%
O	3219	8.5%
N	3171	8.4%
R	2868	7.6%
L	2636	7.0%
S	2297	6.1%
I	2105	5.6%
T	1745	4.6%
C	1456	3.8%
Other values (16)	10316	27.2%

Lowercase Letter

Value	Count	Frequency (%)
r	2	11.8%
n	2	11.8%
e	2	11.8%
w	2	11.8%
a	2	11.8%
l	2	11.8%
i	1	5.9%
t	1	5.9%
c	1	5.9%
s	1	5.9%

Other Punctuation

Value	Count	Frequency (%)
.	82	95.3%
'	4	4.7%

Space Separator

Value	Count	Frequency (%)
	588	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	23	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37923	98.2%
Common	697	1.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	4442	11.7%
E	3651	9.6%
O	3219	8.5%
N	3171	8.4%
R	2868	7.6%
L	2636	7.0%
S	2297	6.1%
I	2105	5.6%
T	1745	4.6%
C	1456	3.8%
Other values (27)	10333	27.2%

Common

Value	Count	Frequency (%)
	588	84.4%
.	82	11.8%
-	23	3.3%
'	4	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	4442	11.5%
E	3651	9.5%
O	3219	8.3%
N	3171	8.2%
R	2868	7.4%
L	2636	6.8%
S	2297	5.9%
I	2105	5.5%
T	1745	4.5%
C	1456	3.8%
Other values (31)	11030	28.6%

facilitydetails_location_loca_3
Text

Distinct	52
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	10564
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AR
2nd row	PA
3rd row	OK
4th row	CA
5th row	AR

Value	Count	Frequency (%)
tx	604	11.4%
fl	396	7.5%
ca	310	5.9%
nc	215	4.1%
ga	214	4.1%
il	185	3.5%
oh	172	3.3%
pa	159	3.0%
mo	156	3.0%
tn	150	2.8%
Other values (42)	2721	51.5%

Most occurring characters

Value	Count	Frequency (%)
A	1566	14.8%
N	948	9.0%
T	870	8.2%
L	864	8.2%
C	789	7.5%
I	645	6.1%
M	640	6.1%
O	612	5.8%
X	604	5.7%
F	396	3.7%
Other values (14)	2630	24.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10564	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1566	14.8%
N	948	9.0%
T	870	8.2%
L	864	8.2%
C	789	7.5%
I	645	6.1%
M	640	6.1%
O	612	5.8%
X	604	5.7%
F	396	3.7%
Other values (14)	2630	24.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10564	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1566	14.8%
N	948	9.0%
T	870	8.2%
L	864	8.2%
C	789	7.5%
I	645	6.1%
M	640	6.1%
O	612	5.8%
X	604	5.7%
F	396	3.7%
Other values (14)	2630	24.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10564	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1566	14.8%
N	948	9.0%
T	870	8.2%
L	864	8.2%
C	789	7.5%
I	645	6.1%
M	640	6.1%
O	612	5.8%
X	604	5.7%
F	396	3.7%
Other values (14)	2630	24.9%

facilitydetails_location_loca_8
Text

Distinct	5186
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Length

Max length	10
Median length	10
Mean length	9.9933737
Min length	5

Characters and Unicode

Total characters	52785
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5090 ?
Unique (%)	96.4%

Sample

1st row	72756-3246
2nd row	18657-8071
3rd row	74464-5439
4th row	95304-9402
5th row	72712-5705

Value	Count	Frequency (%)
63303-3526	2	< 0.1%
72712-0000	2	< 0.1%
76548-0000	2	< 0.1%
20724-1810	2	< 0.1%
85308-0501	2	< 0.1%
78229-5313	2	< 0.1%
07728-2524	2	< 0.1%
76549-0000	2	< 0.1%
12901-6508	2	< 0.1%
32547-3002	2	< 0.1%
Other values (5176)	5262	99.6%

Most occurring characters

Value	Count	Frequency (%)
0	7018	13.3%
1	5389	10.2%
3	5367	10.2%
2	5315	10.1%
-	5275	10.0%
4	4649	8.8%
5	4443	8.4%
7	4428	8.4%
6	4122	7.8%
8	3624	6.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	47510	90.0%
Dash Punctuation	5275	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7018	14.8%
1	5389	11.3%
3	5367	11.3%
2	5315	11.2%
4	4649	9.8%
5	4443	9.4%
7	4428	9.3%
6	4122	8.7%
8	3624	7.6%
9	3155	6.6%

Dash Punctuation

Value	Count	Frequency (%)
-	5275	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	52785	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	7018	13.3%
1	5389	10.2%
3	5367	10.2%
2	5315	10.1%
-	5275	10.0%
4	4649	8.8%
5	4443	8.4%
7	4428	8.4%
6	4122	7.8%
8	3624	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	52785	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	7018	13.3%
1	5389	10.2%
3	5367	10.2%
2	5315	10.1%
-	5275	10.0%
4	4649	8.8%
5	4443	8.4%
7	4428	8.4%
6	4122	7.8%
8	3624	6.9%

businessunit_status_code
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4670579

Minimum	0
Maximum	6
Zeros	27
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	41.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	2
Q3	5
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.5229587
Coefficient of variation (CV)	0.43926543
Kurtosis	-1.8932061
Mean	3.4670579
Median Absolute Deviation (MAD)	0
Skewness	0.0029059456
Sum	18313
Variance	2.3194032
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	2655	50.3%
5	2572	48.7%
0	27	0.5%
6	22	0.4%
1	4	0.1%
4	1	< 0.1%
3	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27	0.5%
1	4	0.1%
2	2655	50.3%
3	1	< 0.1%
4	1	< 0.1%
5	2572	48.7%
6	22	0.4%

Value	Count	Frequency (%)
6	22	0.4%
5	2572	48.7%
4	1	< 0.1%
3	1	< 0.1%
2	2655	50.3%
1	4	0.1%
0	27	0.5%

op_status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.4 KiB

Open	5279
Closed	3

Length

Max length	6
Median length	4
Mean length	4.0011359
Min length	4

Characters and Unicode

Total characters	21134
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Open
2nd row	Open
3rd row	Open
4th row	Open
5th row	Open

Common Values

Value	Count	Frequency (%)
Open	5279	99.9%
Closed	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
open	5279	99.9%
closed	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	5282	25.0%
O	5279	25.0%
p	5279	25.0%
n	5279	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15852	75.0%
Uppercase Letter	5282	25.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5282	33.3%
p	5279	33.3%
n	5279	33.3%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
O	5279	99.9%
C	3	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21134	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5282	25.0%
O	5279	25.0%
p	5279	25.0%
n	5279	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21134	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5282	25.0%
O	5279	25.0%
p	5279	25.0%
n	5279	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Modified_Operating_Hours_
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	33.3%
Missing	5279
Missing (%)	99.9%
Memory size	10.4 KiB

False	3
(Missing)	5279

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3	0.1%
(Missing)	5279	99.9%

Pharmacy_open_to_public_
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	32
Missing (%)	0.6%
Memory size	10.4 KiB

True	5249
False	1
(Missing)	32

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5249	99.4%
False	1	< 0.1%
(Missing)	32	0.6%

Fuel_Station_open_to_public_
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	32
Missing (%)	0.6%
Memory size	10.4 KiB

True	5250
(Missing)	32

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5250	99.4%
(Missing)	32	0.6%

bu_num
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	5282
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3196.6717

Minimum	1
Maximum	11017
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.4 KiB

Quantile statistics

Minimum	1
5-th percentile	279.05
Q1	1376.25
median	2818.5
Q3	4946.75
95-th percentile	6970.85
Maximum	11017
Range	11016
Interquartile range (IQR)	3570.5

Descriptive statistics

Standard deviation	2167.5044
Coefficient of variation (CV)	0.67805035
Kurtosis	-0.72529718
Mean	3196.6717
Median Absolute Deviation (MAD)	1698.5
Skewness	0.47916053
Sum	16884820
Variance	4698075.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
5907	1	< 0.1%
590	1	< 0.1%
59	1	< 0.1%
5899	1	< 0.1%
5898	1	< 0.1%
5894	1	< 0.1%
5893	1	< 0.1%
5891	1	< 0.1%
5890	1	< 0.1%
Other values (5272)	5272	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
11017	1	< 0.1%
9894	1	< 0.1%
8958	1	< 0.1%
8930	1	< 0.1%
8861	1	< 0.1%
8331	1	< 0.1%
8299	1	< 0.1%
8298	1	< 0.1%
8297	1	< 0.1%
8296	1	< 0.1%

Grocery_delivery_service
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	467
Missing (%)	8.8%
Memory size	10.4 KiB

False	3157
True	1658
(Missing)	467

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3157	59.8%
True	1658	31.4%
(Missing)	467	8.8%

Grocery_delivery_status
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	2417
Missing (%)	45.8%
Memory size	41.4 KiB

Available	2346
Not Available	519

Length

Max length	13
Median length	9
Mean length	9.7246073
Min length	9

Characters and Unicode

Total characters	27861
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Available
2nd row	Not Available
3rd row	Not Available
4th row	Available
5th row	Available

Common Values

Value	Count	Frequency (%)
Available	2346	44.4%
Not Available	519	9.8%
(Missing)	2417	45.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
available	2865	84.7%
not	519	15.3%

Most occurring characters

Value	Count	Frequency (%)
a	5730	20.6%
l	5730	20.6%
A	2865	10.3%
v	2865	10.3%
i	2865	10.3%
b	2865	10.3%
e	2865	10.3%
N	519	1.9%
o	519	1.9%
t	519	1.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	23958	86.0%
Uppercase Letter	3384	12.1%
Space Separator	519	1.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5730	23.9%
l	5730	23.9%
v	2865	12.0%
i	2865	12.0%
b	2865	12.0%
e	2865	12.0%
o	519	2.2%
t	519	2.2%

Uppercase Letter

Value	Count	Frequency (%)
A	2865	84.7%
N	519	15.3%

Space Separator

Value	Count	Frequency (%)
	519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27342	98.1%
Common	519	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	5730	21.0%
l	5730	21.0%
A	2865	10.5%
v	2865	10.5%
i	2865	10.5%
b	2865	10.5%
e	2865	10.5%
N	519	1.9%
o	519	1.9%
t	519	1.9%

Common

Value	Count	Frequency (%)
	519	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27861	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	5730	20.6%
l	5730	20.6%
A	2865	10.3%
v	2865	10.3%
i	2865	10.3%
b	2865	10.3%
e	2865	10.3%
N	519	1.9%
o	519	1.9%
t	519	1.9%

Online_grocery_pickup
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	138
Missing (%)	2.6%
Memory size	10.4 KiB

True	3616
False	1528
(Missing)	138

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3616	68.5%
False	1528	28.9%
(Missing)	138	2.6%

Online_grocery_pickup_status
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	1505
Missing (%)	28.5%
Memory size	41.4 KiB

Available	3144
Not Available	633

Length

Max length	13
Median length	9
Mean length	9.6703733
Min length	9

Characters and Unicode

Total characters	36525
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Available
2nd row	Available
3rd row	Available
4th row	Not Available
5th row	Not Available

Common Values

Value	Count	Frequency (%)
Available	3144	59.5%
Not Available	633	12.0%
(Missing)	1505	28.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
available	3777	85.6%
not	633	14.4%

Most occurring characters

Value	Count	Frequency (%)
a	7554	20.7%
l	7554	20.7%
A	3777	10.3%
v	3777	10.3%
i	3777	10.3%
b	3777	10.3%
e	3777	10.3%
N	633	1.7%
o	633	1.7%
t	633	1.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	31482	86.2%
Uppercase Letter	4410	12.1%
Space Separator	633	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	7554	24.0%
l	7554	24.0%
v	3777	12.0%
i	3777	12.0%
b	3777	12.0%
e	3777	12.0%
o	633	2.0%
t	633	2.0%

Uppercase Letter

Value	Count	Frequency (%)
A	3777	85.6%
N	633	14.4%

Space Separator

Value	Count	Frequency (%)
	633	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35892	98.3%
Common	633	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	7554	21.0%
l	7554	21.0%
A	3777	10.5%
v	3777	10.5%
i	3777	10.5%
b	3777	10.5%
e	3777	10.5%
N	633	1.8%
o	633	1.8%
t	633	1.8%

Common

Value	Count	Frequency (%)
	633	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36525	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	7554	20.7%
l	7554	20.7%
A	3777	10.3%
v	3777	10.3%
i	3777	10.3%
b	3777	10.3%
e	3777	10.3%
N	633	1.7%
o	633	1.7%
t	633	1.7%

Auto

Heatmap
Table

	X	Y	objectid	businessunit_number	businessunit_status_code	bu_num	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	op_status	Pharmacy_open_to_public_	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
X	1.000	0.084	-0.050	0.025	0.010	0.025	0.262	0.021	0.036	0.000	0.000	0.045	0.057	0.029	0.051
Y	0.084	1.000	-0.181	0.007	0.100	0.007	0.222	0.055	0.046	0.000	0.000	0.059	0.000	0.000	0.010
objectid	-0.050	-0.181	1.000	0.476	-0.201	0.476	0.196	0.498	0.024	0.041	0.000	0.059	0.000	0.037	0.000
businessunit_number	0.025	0.007	0.476	1.000	-0.551	1.000	0.301	0.664	0.040	0.000	0.000	0.116	0.003	0.053	0.037
businessunit_status_code	0.010	0.100	-0.201	-0.551	1.000	-0.551	0.283	0.062	0.976	0.000	0.000	0.043	0.000	0.076	0.000
bu_num	0.025	0.007	0.476	1.000	-0.551	1.000	0.301	0.664	0.040	0.000	0.000	0.116	0.003	0.053	0.037
businessunit_banner_description	0.262	0.222	0.196	0.301	0.283	0.301	1.000	0.999	0.217	0.000	0.000	0.200	0.048	0.172	0.044
businessunit_type_description	0.021	0.055	0.498	0.664	0.062	0.664	0.999	1.000	0.000	0.000	0.000	0.187	0.000	0.105	0.009
businessunit_isstoreopen	0.036	0.046	0.024	0.040	0.976	0.040	0.217	0.000	1.000	0.000	0.000	0.000	0.000	0.011	0.000
op_status	0.000	0.000	0.041	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000
Pharmacy_open_to_public_	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	1.000	0.000	1.000
Grocery_delivery_service	0.045	0.059	0.059	0.116	0.043	0.116	0.200	0.187	0.000	0.000	0.000	1.000	0.331	0.422	0.249
Grocery_delivery_status	0.057	0.000	0.000	0.003	0.000	0.003	0.048	0.000	0.000	0.000	1.000	0.331	1.000	0.236	0.918
Online_grocery_pickup	0.029	0.000	0.037	0.053	0.076	0.053	0.172	0.105	0.011	0.000	0.000	0.422	0.236	1.000	0.175
Online_grocery_pickup_status	0.051	0.010	0.000	0.037	0.000	0.037	0.044	0.009	0.000	0.000	1.000	0.249	0.918	0.175	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	X	Y	objectid	businessunit_name	businessunit_number	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	facilitydetails_location_locati	facilitydetails_location_loca_1	facilitydetails_location_loca_2	facilitydetails_location_loca_3	facilitydetails_location_loca_8	businessunit_status_code	op_status	Modified_Operating_Hours_	Pharmacy_open_to_public_	Fuel_Station_open_to_public_	bu_num	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
0	-94.149054	36.331300	29040	ROGERS, AR	1	WM Supercenter	Retail	True	2110 W WALNUT ST	ROGERS	BENTON	AR	72756-3246	5	Open	NaN	Y	Y	1	Yes	NaN	Yes	Not Available
1	-75.947441	41.523981	29041	TUNKHANNOCK, PA	2024	WM Supercenter	Retail	True	808 HUNTER HWY	TUNKHANNOCK	WYOMING	PA	18657-8071	5	Open	NaN	Y	Y	2024	No	Available	No	Available
2	-94.979814	35.888807	29042	TAHLEQUAH OK	10	WM Supercenter	Retail	True	2020 S MUSKOGEE AVE	TAHLEQUAH	CHEROKEE	OK	74464-5439	5	Open	NaN	Y	Y	10	No	NaN	No	Available
3	-121.471715	37.751659	29043	TRACY, CA	2025	WM Supercenter	Retail	True	3010 W GRANT LINE RD	TRACY	SAN JOAQUIN	CA	95304-9402	5	Open	NaN	Y	Y	2025	No	Not Available	No	Not Available
4	-94.224844	36.368173	29044	BENTONVILLE, AR	100	WM Supercenter	Retail	True	406 S WALTON BLVD	BENTONVILLE	BENTON	AR	72712-5705	5	Open	NaN	Y	Y	100	No	Not Available	No	Not Available
5	-66.642578	17.997360	29045	PONCE-PR	2026	WM Supercenter	Retail	True	3305 AVE.BARAMAYA SUITE 100	PONCE	PONCE	PR	00728-0000	5	Open	NaN	Y	Y	2026	NaN	NaN	Yes	NaN
6	-97.477003	25.925142	29046	BROWNSVILLE TX	1000	WM Supercenter	Retail	True	2721 BOCA CHICA BLVD	BROWNSVILLE	CAMERON	TX	78521-3501	5	Open	NaN	Y	Y	1000	Yes	NaN	Yes	Available
7	-78.835052	39.624903	29047	LAVALE, MD	2027	WM Supercenter	Retail	True	12500 COUNTRY CLUB MALL RD	LAVALE	ALLEGANY	MD	21502-7553	5	Open	NaN	Y	Y	2027	Yes	Available	Yes	Available
8	-104.664898	38.232316	29048	PUEBLO, CO	1001	WM Supercenter	Retail	True	4080 W NORTHERN AVE	PUEBLO	PUEBLO	CO	81005-3503	5	Open	NaN	Y	Y	1001	Yes	Available	Yes	Available
9	-117.455339	33.937071	29049	RIVERSIDE (S), CA	2028	WM Supercenter	Retail	True	5200 VAN BUREN BLVD	RIVERSIDE	RIVERSIDE	CA	92503-2544	5	Open	NaN	Y	Y	2028	No	NaN	Yes	NaN

	X	Y	objectid	businessunit_name	businessunit_number	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	facilitydetails_location_locati	facilitydetails_location_loca_1	facilitydetails_location_loca_2	facilitydetails_location_loca_3	facilitydetails_location_loca_8	businessunit_status_code	op_status	Modified_Operating_Hours_	Pharmacy_open_to_public_	Fuel_Station_open_to_public_	bu_num	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
5272	-82.455718	29.063309	36688	DUNNELLON FL	960	WM Supercenter	Retail	True	11012 NO. WILLIAMS ST	DUNNELLON	MARION	FL	34432-8310	5	Open	NaN	Y	Y	960	Yes	Available	Yes	Available
5273	-90.498285	30.074716	36690	LAPLACE LA	961	WM Supercenter	Retail	True	1616 W AIRLINE HWY	LA PLACE	ST. JOHN THE BAPTIST PARISH	LA	70068-3331	5	Open	NaN	Y	Y	961	No	Available	Yes	Available
5274	-104.523275	37.138728	36693	TRINIDAD CO	962	WM Supercenter	Retail	True	2921 TOUPAL DR	TRINIDAD	LAS ANIMAS	CO	81082-8740	5	Open	NaN	Y	Y	962	Yes	Available	Yes	Available
5275	-97.794862	32.731493	36695	WEATHERFORD TX	963	WM Supercenter	Retail	True	1836 S MAIN ST	WEATHERFORD	PARKER	TX	76086-5506	5	Open	NaN	Y	Y	963	No	Available	Yes	Available
5276	-106.311596	31.682898	36698	EL PASO (S) TX	964	WM Supercenter	Retail	True	9441 ALAMEDA AVE	EL PASO	EL PASO	TX	79907-5601	5	Open	NaN	Y	Y	964	Yes	Available	Yes	Available
5277	-90.508577	44.021024	36700	TOMAH WI	965	WM Supercenter	Retail	True	222 W MCCOY BLVD	TOMAH	MONROE	WI	54660-3291	5	Open	NaN	Y	Y	965	No	NaN	Yes	NaN
5278	-108.561994	37.346568	36702	CORTEZ CO	966	WM Supercenter	Retail	True	1835 E MAIN ST	CORTEZ	MONTEZUMA	CO	81321-3037	5	Open	NaN	Y	Y	966	Yes	NaN	Yes	NaN
5279	-82.631218	28.458397	36704	SPRINGHILL / BROOKSVILLE	967	WM Supercenter	Retail	True	1485 COMMERCIAL WAY	SPRING HILL	HERNANDO	FL	34606-4525	5	Open	NaN	Y	Y	967	Yes	Available	Yes	Available
5280	-81.722251	28.006651	36705	WINTER HAVEN FL	968	WM Supercenter	Retail	True	355 CYPRESS GARDENS BLVD	WINTER HAVEN	POLK	FL	33880-4452	5	Open	NaN	Y	Y	968	Yes	Available	Yes	Available
5281	-89.088697	30.423224	36706	GULFPORT MS	969	WM Supercenter	Retail	True	9350 HIGHWAY 49	GULFPORT	HARRISON	MS	39503-4213	5	Open	NaN	Y	Y	969	No	Not Available	Yes	Available

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin